Pandas Profiling Report

Dataset statistics

Number of variables	32
Number of observations	1219694
Missing cells	3700183
Missing cells (%)	9.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.2 GiB
Average record size in memory	1.0 KiB

Variable types

Numeric	12
Boolean	4
Categorical	14
Unsupported	2

Alerts

`Net_Sales_Proceeds` has constant value "False"	Constant
`Non_MI_Recoveries` has constant value "FRM"	Constant
`Estimated_Loan_to_Value_(ELTV)` has constant value "True"	Constant
`Current_Month_Modification_Cost` has constant value "False"	Constant
`Expenses` has a high cardinality: 54 distinct values	High cardinality
`Taxes_and_Insurance` has a high cardinality: 1219694 distinct values	High cardinality
`Monthly_Reporting_Period` is highly overall correlated with `Current_Loan_Delinquency_Status`	High correlation
`Current_Loan_Delinquency_Status` is highly overall correlated with `Monthly_Reporting_Period` and 1 other fields	High correlation
`Loan_Age` is highly overall correlated with `Expenses`	High correlation
`Remaining_Months_to_Legal_Maturity` is highly overall correlated with `Zero_Balance_Code` and 2 other fields	High correlation
`Zero_Balance_Code` is highly overall correlated with `Remaining_Months_to_Legal_Maturity` and 1 other fields	High correlation
`Current_Deferred_UPB` is highly overall correlated with `Remaining_Months_to_Legal_Maturity` and 3 other fields	High correlation
`Due_Date_of_Last_Paid_Installment_(DDLPI)` is highly overall correlated with `Actual_Loss_Calculation`	High correlation
`Maintenance_and_Preservation_Costs` is highly overall correlated with `Expenses`	High correlation
`Actual_Loss_Calculation` is highly overall correlated with `Current_Loan_Delinquency_Status` and 1 other fields	High correlation
`Current_Actual_UPB` is highly overall correlated with `Current_Deferred_UPB` and 1 other fields	High correlation
`MI_Recoveries` is highly overall correlated with `Step_Modification_Flag` and 1 other fields	High correlation
`Expenses` is highly overall correlated with `Loan_Age` and 1 other fields	High correlation
`Miscellaneous_Expenses` is highly overall correlated with `Current_Actual_UPB`	High correlation
`Step_Modification_Flag` is highly overall correlated with `MI_Recoveries` and 1 other fields	High correlation
`Deferred_Payment_Plan` is highly overall correlated with `MI_Recoveries` and 1 other fields	High correlation
`Interest_Bearing_UPB` is highly overall correlated with `Remaining_Months_to_Legal_Maturity` and 1 other fields	High correlation
`Current_Actual_UPB` is highly imbalanced (56.6%)	Imbalance
`Defect_Settlement_Date` is highly imbalanced (92.1%)	Imbalance
`Modification_Flag` is highly imbalanced (67.2%)	Imbalance
`Modification_Cost` is highly imbalanced (54.8%)	Imbalance
`Delinquent_Accrued_Interest` is highly imbalanced (85.1%)	Imbalance
`Interest_Bearing_UPB` is highly imbalanced (52.0%)	Imbalance
`Loan_Age` has 95617 (7.8%) missing values	Missing
`Estimated_Loan_to_Value_(ELTV)` has 1165178 (95.5%) missing values	Missing
`Zero_Balance_Removal_UPB` has 1219694 (100.0%) missing values	Missing
`Delinquency_Due_to_Disaster` has 1219694 (100.0%) missing values	Missing
`Loan_Sequence_Number` is highly skewed (γ1 = 76.65065439)	Skewed
`Monthly_Reporting_Period` is highly skewed (γ1 = 41.23688602)	Skewed
`Taxes_and_Insurance` is uniformly distributed	Uniform
`Taxes_and_Insurance` has unique values	Unique
`Zero_Balance_Removal_UPB` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Delinquency_Due_to_Disaster` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Remaining_Months_to_Legal_Maturity` has 1006523 (82.5%) zeros	Zeros

Reproduction

Analysis started	2023-10-06 14:00:30.565677
Analysis finished	2023-10-06 14:03:22.336422
Duration	2 minutes and 51.77 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

Loan_Sequence_Number
Real number (ℝ)

Distinct	240
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	758.45945

Minimum	300
Maximum	9999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.3 MiB

Quantile statistics

Minimum	300
5-th percentile	677
Q1	730
median	767
Q3	791
95-th percentile	810
Maximum	9999
Range	9699
Interquartile range (IQR)	61

Descriptive statistics

Standard deviation	98.111925
Coefficient of variation (CV)	0.12935685
Kurtosis	7222.6701
Mean	758.45945
Median Absolute Deviation (MAD)	29
Skewness	76.650654
Sum	9.2508844 × 10⁸
Variance	9625.9499
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
801	16676	1.4%
790	15896	1.3%
787	15396	1.3%
797	15323	1.3%
791	15225	1.2%
809	15183	1.2%
796	14733	1.2%
800	14561	1.2%
798	14445	1.2%
793	14124	1.2%
Other values (230)	1068132	87.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
300	1	< 0.1%
571	1	< 0.1%
600	15	< 0.1%
601	10	< 0.1%
602	13	< 0.1%
603	9	< 0.1%
604	14	< 0.1%
605	18	< 0.1%
606	15	< 0.1%
607	15	< 0.1%

Value	Count	Frequency (%)
9999	112	< 0.1%
839	2	< 0.1%
835	1	< 0.1%
834	5	< 0.1%
833	2	< 0.1%
832	58	< 0.1%
831	12	< 0.1%
830	26	< 0.1%
829	195	< 0.1%
828	60	< 0.1%

Monthly_Reporting_Period
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	202104.11

Minimum	202102
Maximum	202301
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.3 MiB

Quantile statistics

Minimum	202102
5-th percentile	202103
Q1	202103
median	202104
Q3	202105
95-th percentile	202105
Maximum	202301
Range	199
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.9899804
Coefficient of variation (CV)	9.8463134 × 10^-6
Kurtosis	2090.9932
Mean	202104.11
Median Absolute Deviation (MAD)	1
Skewness	41.236886
Sum	2.4650517 × 10¹¹
Variance	3.9600219
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
202105	439802	36.1%
202104	395399	32.4%
202103	369832	30.3%
202106	12147	1.0%
202102	1943	0.2%
202203	97	< 0.1%
202202	92	< 0.1%
202201	87	< 0.1%
202111	56	< 0.1%
202204	52	< 0.1%
Other values (13)	187	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
202102	1943	0.2%
202103	369832	30.3%
202104	395399	32.4%
202105	439802	36.1%
202106	12147	1.0%
202107	5	< 0.1%
202108	12	< 0.1%
202109	20	< 0.1%
202110	30	< 0.1%
202111	56	< 0.1%

Value	Count	Frequency (%)
202301	1	< 0.1%
202211	1	< 0.1%
202210	7	< 0.1%
202209	7	< 0.1%
202208	5	< 0.1%
202207	10	< 0.1%
202206	15	< 0.1%
202205	27	< 0.1%
202204	52	< 0.1%
202203	97	< 0.1%

Current_Actual_UPB
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

False	1110746
True	108948

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1110746	91.1%
True	108948	8.9%

Current_Loan_Delinquency_Status
Real number (ℝ)

Distinct	283
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	204743.05

Minimum	202803
Maximum	205212
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.3 MiB

Quantile statistics

Minimum	202803
5-th percentile	203602
Q1	204402
median	205102
Q3	205104
95-th percentile	205104
Maximum	205212
Range	2409
Interquartile range (IQR)	702

Descriptive statistics

Standard deviation	616.82575
Coefficient of variation (CV)	0.0030126822
Kurtosis	-0.20495481
Mean	204743.05
Median Absolute Deviation (MAD)	2
Skewness	-1.2566847
Sum	2.4972387 × 10¹¹
Variance	380474
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
205104	313160	25.7%
205103	286612	23.5%
205102	276290	22.7%
203604	82566	6.8%
203603	68469	5.6%
203602	57573	4.7%
204104	27650	2.3%
204103	24270	2.0%
204102	21452	1.8%
205105	7433	0.6%
Other values (273)	54219	4.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
202803	1	< 0.1%
202804	3	< 0.1%
202805	1	< 0.1%
202806	1	< 0.1%
202808	1	< 0.1%
202901	1	< 0.1%
202902	70	< 0.1%
202903	94	< 0.1%
202904	127	< 0.1%
202905	3	< 0.1%

Value	Count	Frequency (%)
205212	1	< 0.1%
205210	1	< 0.1%
205209	7	< 0.1%
205208	7	< 0.1%
205207	3	< 0.1%
205206	7	< 0.1%
205205	13	< 0.1%
205204	26	< 0.1%
205203	45	< 0.1%
205202	93	< 0.1%

Loan_Age
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	408
Distinct (%)	< 0.1%
Missing	95617
Missing (%)	7.8%
Infinite	0
Infinite (%)	0.0%
Mean	30517.519

Minimum	10180
Maximum	49740
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.3 MiB

Quantile statistics

Minimum	10180
5-th percentile	12060
Q1	19430
median	33340
Q3	40140
95-th percentile	47664
Maximum	49740
Range	39560
Interquartile range (IQR)	20710

Descriptive statistics

Standard deviation	11322.608
Coefficient of variation (CV)	0.37101994
Kurtosis	-1.2287425
Mean	30517.519
Median Absolute Deviation (MAD)	8600
Skewness	-0.1987437
Sum	3.4304041 × 10¹⁰
Variance	1.2820146 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
31084	36818	3.0%
16984	34887	2.9%
38060	34623	2.8%
47894	31034	2.5%
12060	25815	2.1%
19740	22853	1.9%
40140	22464	1.8%
33460	20612	1.7%
42644	20347	1.7%
26420	19886	1.6%
Other values (398)	854738	70.1%
(Missing)	95617	7.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10180	310	< 0.1%
10380	1	< 0.1%
10420	2108	0.2%
10500	130	< 0.1%
10540	569	< 0.1%
10580	1877	0.2%
10740	2832	0.2%
10780	205	< 0.1%
10900	2689	0.2%
11020	235	< 0.1%

Value	Count	Frequency (%)
49740	660	0.1%
49700	786	0.1%
49660	985	0.1%
49620	1687	0.1%
49500	1	< 0.1%
49420	556	< 0.1%
49340	4399	0.4%
49180	1715	0.1%
49020	633	0.1%
48900	1417	0.1%

Remaining_Months_to_Legal_Maturity
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.0664224

Minimum	0
Maximum	55
Zeros	1006523
Zeros (%)	82.5%
Negative	0
Negative (%)	0.0%
Memory size	9.3 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	30
Maximum	55
Range	55
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	9.3919546
Coefficient of variation (CV)	2.3096358
Kurtosis	2.5661946
Mean	4.0664224
Median Absolute Deviation (MAD)	0
Skewness	2.0621656
Sum	4959791
Variance	88.208811
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
0	1006523	82.5%
25	79157	6.5%
30	69593	5.7%
12	50326	4.1%
35	6065	0.5%
6	5495	0.5%
18	1396	0.1%
16	1090	0.1%
15	12	< 0.1%
20	6	< 0.1%
Other values (21)	31	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1006523	82.5%
6	5495	0.5%
12	50326	4.1%
14	2	< 0.1%
15	12	< 0.1%
16	1090	0.1%
18	1396	0.1%
20	6	< 0.1%
22	1	< 0.1%
23	1	< 0.1%

Value	Count	Frequency (%)
55	1	< 0.1%
50	1	< 0.1%
49	1	< 0.1%
47	1	< 0.1%
45	2	< 0.1%
43	1	< 0.1%
42	1	< 0.1%
38	1	< 0.1%
37	1	< 0.1%
36	4	< 0.1%

Defect_Settlement_Date
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	67.5 MiB

1	1196476
2	16687
3	3616
4	2915

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1219694
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	1196476	98.1%
2	16687	1.4%
3	3616	0.3%
4	2915	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	1196476	98.1%
2	16687	1.4%
3	3616	0.3%
4	2915	0.2%

Most occurring characters

Value	Count	Frequency (%)
1	1196476	98.1%
2	16687	1.4%
3	3616	0.3%
4	2915	0.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1219694	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	1196476	98.1%
2	16687	1.4%
3	3616	0.3%
4	2915	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	1219694	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	1196476	98.1%
2	16687	1.4%
3	3616	0.3%
4	2915	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1219694	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	1196476	98.1%
2	16687	1.4%
3	3616	0.3%
4	2915	0.2%

Modification_Flag
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	67.5 MiB

P	1111055
I	65538
S	43101

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1219694
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	P
2nd row	P
3rd row	P
4th row	P
5th row	S

Common Values

Value	Count	Frequency (%)
P	1111055	91.1%
I	65538	5.4%
S	43101	3.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
p	1111055	91.1%
i	65538	5.4%
s	43101	3.5%

Most occurring characters

Value	Count	Frequency (%)
P	1111055	91.1%
I	65538	5.4%
S	43101	3.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1219694	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	1111055	91.1%
I	65538	5.4%
S	43101	3.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1219694	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	1111055	91.1%
I	65538	5.4%
S	43101	3.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1219694	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	1111055	91.1%
I	65538	5.4%
S	43101	3.5%

Zero_Balance_Code
Real number (ℝ)

Distinct	104
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	68.428521

Minimum	3
Maximum	999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.3 MiB

Quantile statistics

Minimum	3
5-th percentile	36
Q1	58
median	71
Q3	80
95-th percentile	95
Maximum	999
Range	996
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	17.032429
Coefficient of variation (CV)	0.24890833
Kurtosis	7.3123924
Mean	68.428521
Median Absolute Deviation (MAD)	10
Skewness	-0.46031166
Sum	83461856
Variance	290.10363
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
80	159436	13.1%
75	75649	6.2%
95	65453	5.4%
70	55248	4.5%
60	46423	3.8%
90	40932	3.4%
69	29352	2.4%
74	27123	2.2%
79	25466	2.1%
85	24358	2.0%
Other values (94)	670254	55.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	1	< 0.1%
4	3	< 0.1%
5	15	< 0.1%
6	29	< 0.1%
7	62	< 0.1%
8	76	< 0.1%
9	120	< 0.1%
10	163	< 0.1%
11	224	< 0.1%
12	318	< 0.1%

Value	Count	Frequency (%)
999	1	< 0.1%
105	18	< 0.1%
104	29	< 0.1%
103	53	< 0.1%
102	235	< 0.1%
101	308	< 0.1%
100	450	< 0.1%
99	89	< 0.1%
98	49	< 0.1%
97	16119	1.3%

Zero_Balance_Effective_Date
Real number (ℝ)

Distinct	52
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.008357

Minimum	1
Maximum	999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.3 MiB

Quantile statistics

Minimum	1
5-th percentile	16
Q1	26
median	34
Q3	41
95-th percentile	48
Maximum	999
Range	998
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	10.993696
Coefficient of variation (CV)	0.33305796
Kurtosis	1562.3705
Mean	33.008357
Median Absolute Deviation (MAD)	8
Skewness	17.60132
Sum	40260095
Variance	120.86135
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
45	43273	3.5%
44	42989	3.5%
43	42843	3.5%
42	42243	3.5%
41	41411	3.4%
39	41142	3.4%
38	41110	3.4%
40	41045	3.4%
37	40670	3.3%
36	40612	3.3%
Other values (42)	802356	65.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	64	< 0.1%
2	113	< 0.1%
3	171	< 0.1%
4	241	< 0.1%
5	382	< 0.1%
6	645	0.1%
7	968	0.1%
8	1511	0.1%
9	2287	0.2%
10	3411	0.3%

Value	Count	Frequency (%)
999	32	< 0.1%
51	6	< 0.1%
50	20718	1.7%
49	23955	2.0%
48	23305	1.9%
47	23574	1.9%
46	25059	2.1%
45	43273	3.5%
44	42989	3.5%
43	42843	3.5%

Current_Interest_Rate
Real number (ℝ)

Distinct	1071
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	291095.95

Minimum	12000
Maximum	1582000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.3 MiB

Quantile statistics

Minimum	12000
5-th percentile	100000
Q1	179000
median	263000
Q3	375000
95-th percentile	548000
Maximum	1582000
Range	1570000
Interquartile range (IQR)	196000

Descriptive statistics

Standard deviation	148360.86
Coefficient of variation (CV)	0.50966307
Kurtosis	0.96798377
Mean	291095.95
Median Absolute Deviation (MAD)	94000
Skewness	0.95308568
Sum	3.5504799 × 10¹¹
Variance	2.2010944 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
548000	19487	1.6%
200000	10222	0.8%
300000	9045	0.7%
150000	7903	0.6%
250000	7461	0.6%
240000	6464	0.5%
510000	6272	0.5%
280000	6094	0.5%
100000	6038	0.5%
180000	5961	0.5%
Other values (1061)	1134747	93.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12000	1	< 0.1%
13000	2	< 0.1%
14000	1	< 0.1%
15000	2	< 0.1%
17000	2	< 0.1%
20000	8	< 0.1%
21000	4	< 0.1%
22000	10	< 0.1%
23000	13	< 0.1%
24000	23	< 0.1%

Value	Count	Frequency (%)
1582000	4	< 0.1%
1581000	1	< 0.1%
1551000	1	< 0.1%
1538000	2	< 0.1%
1520000	1	< 0.1%
1500000	2	< 0.1%
1495000	1	< 0.1%
1493000	1	< 0.1%
1478000	1	< 0.1%
1473000	1	< 0.1%

Current_Deferred_UPB
Real number (ℝ)

Distinct	96
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	68.199353

Minimum	3
Maximum	101
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.3 MiB

Quantile statistics

Minimum	3
5-th percentile	36
Q1	58
median	70
Q3	80
95-th percentile	95
Maximum	101
Range	98
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	17.049955
Coefficient of variation (CV)	0.25000171
Kurtosis	0.001959364
Mean	68.199353
Median Absolute Deviation (MAD)	10
Skewness	-0.58672812
Sum	83182342
Variance	290.70096
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
80	158893	13.0%
75	76040	6.2%
95	65353	5.4%
70	55505	4.6%
60	47038	3.9%
90	39526	3.2%
69	29492	2.4%
74	27128	2.2%
79	25161	2.1%
59	23800	2.0%
Other values (86)	671758	55.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	1	< 0.1%
4	3	< 0.1%
5	15	< 0.1%
6	30	< 0.1%
7	63	< 0.1%
8	77	< 0.1%
9	124	< 0.1%
10	169	< 0.1%
11	230	< 0.1%
12	329	< 0.1%

Value	Count	Frequency (%)
101	1	< 0.1%
97	16871	1.4%
96	327	< 0.1%
95	65353	5.4%
94	3815	0.3%
93	4065	0.3%
92	4047	0.3%
91	2920	0.2%
90	39526	3.2%
89	7695	0.6%

Due_Date_of_Last_Paid_Installment_(DDLPI)
Real number (ℝ)

Distinct	1637
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.7973943

Minimum	1.5
Maximum	6.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.3 MiB

Quantile statistics

Minimum	1.5
5-th percentile	2.25
Q1	2.625
median	2.875
Q3	2.99
95-th percentile	3.375
Maximum	6.5
Range	5
Interquartile range (IQR)	0.365

Descriptive statistics

Standard deviation	0.33631568
Coefficient of variation (CV)	0.12022462
Kurtosis	2.7277912
Mean	2.7973943
Median Absolute Deviation (MAD)	0.125
Skewness	0.49359934
Sum	3411965.1
Variance	0.11310823
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.875	251124	20.6%
2.75	206922	17.0%
2.625	109609	9.0%
2.5	104228	8.5%
2.99	92882	7.6%
3	70753	5.8%
2.375	62782	5.1%
2.25	58164	4.8%
3.125	53926	4.4%
3.25	35000	2.9%
Other values (1627)	174304	14.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.5	2	< 0.1%
1.625	3	< 0.1%
1.75	1950	0.2%
1.751	1	< 0.1%
1.756	1	< 0.1%
1.766	1	< 0.1%
1.775	2	< 0.1%
1.799	2	< 0.1%
1.8	2	< 0.1%
1.802	1	< 0.1%

Value	Count	Frequency (%)
6.5	1	< 0.1%
6.125	1	< 0.1%
6	1	< 0.1%
5.875	3	< 0.1%
5.75	1	< 0.1%
5.625	2	< 0.1%
5.5	31	< 0.1%
5.49	2	< 0.1%
5.375	12	< 0.1%
5.25	68	< 0.1%

MI_Recoveries
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	67.5 MiB

R	713865
C	342082
B	163747

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1219694
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	C
2nd row	R
3rd row	R
4th row	R
5th row	R

Common Values

Value	Count	Frequency (%)
R	713865	58.5%
C	342082	28.0%
B	163747	13.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
r	713865	58.5%
c	342082	28.0%
b	163747	13.4%

Most occurring characters

Value	Count	Frequency (%)
R	713865	58.5%
C	342082	28.0%
B	163747	13.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1219694	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	713865	58.5%
C	342082	28.0%
B	163747	13.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1219694	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	713865	58.5%
C	342082	28.0%
B	163747	13.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1219694	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	713865	58.5%
C	342082	28.0%
B	163747	13.4%

Net_Sales_Proceeds
Boolean

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

False	1219694

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1219694	100.0%

Non_MI_Recoveries
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	69.8 MiB

FRM	1219694

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	3659082
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FRM
2nd row	FRM
3rd row	FRM
4th row	FRM
5th row	FRM

Common Values

Value	Count	Frequency (%)
FRM	1219694	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
frm	1219694	100.0%

Most occurring characters

Value	Count	Frequency (%)
F	1219694	33.3%
R	1219694	33.3%
M	1219694	33.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3659082	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
F	1219694	33.3%
R	1219694	33.3%
M	1219694	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3659082	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
F	1219694	33.3%
R	1219694	33.3%
M	1219694	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3659082	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
F	1219694	33.3%
R	1219694	33.3%
M	1219694	33.3%

Expenses
Categorical

HIGH CARDINALITY HIGH CORRELATION

Distinct	54
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	68.6 MiB

CA	183913
TX	74595
FL	72294
IL	51483
AZ	45836
Other values (49)	791573

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	2439388
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NJ
2nd row	CO
3rd row	DE
4th row	KY
5th row	MA

Common Values

Value	Count	Frequency (%)
CA	183913	15.1%
TX	74595	6.1%
FL	72294	5.9%
IL	51483	4.2%
AZ	45836	3.8%
WA	42037	3.4%
OH	40598	3.3%
VA	40530	3.3%
CO	39707	3.3%
MI	39033	3.2%
Other values (44)	589668	48.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ca	183913	15.1%
tx	74595	6.1%
fl	72294	5.9%
il	51483	4.2%
az	45836	3.8%
wa	42037	3.4%
oh	40598	3.3%
va	40530	3.3%
co	39707	3.3%
mi	39033	3.2%
Other values (44)	589668	48.3%

Most occurring characters

Value	Count	Frequency (%)
A	460542	18.9%
C	291306	11.9%
N	212183	8.7%
M	172417	7.1%
I	161501	6.6%
L	147230	6.0%
T	138181	5.7%
O	136290	5.6%
X	74595	3.1%
F	72294	3.0%
Other values (14)	572849	23.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2439388	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	460542	18.9%
C	291306	11.9%
N	212183	8.7%
M	172417	7.1%
I	161501	6.6%
L	147230	6.0%
T	138181	5.7%
O	136290	5.6%
X	74595	3.1%
F	72294	3.0%
Other values (14)	572849	23.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2439388	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	460542	18.9%
C	291306	11.9%
N	212183	8.7%
M	172417	7.1%
I	161501	6.6%
L	147230	6.0%
T	138181	5.7%
O	136290	5.6%
X	74595	3.1%
F	72294	3.0%
Other values (14)	572849	23.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2439388	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	460542	18.9%
C	291306	11.9%
N	212183	8.7%
M	172417	7.1%
I	161501	6.6%
L	147230	6.0%
T	138181	5.7%
O	136290	5.6%
X	74595	3.1%
F	72294	3.0%
Other values (14)	572849	23.5%

Legal_Costs
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	68.6 MiB

SF	784789
PU	338101
CO	91157
MH	4190
CP	1457

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	2439388
Distinct characters	8
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PU
2nd row	SF
3rd row	SF
4th row	SF
5th row	SF

Common Values

Value	Count	Frequency (%)
SF	784789	64.3%
PU	338101	27.7%
CO	91157	7.5%
MH	4190	0.3%
CP	1457	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
sf	784789	64.3%
pu	338101	27.7%
co	91157	7.5%
mh	4190	0.3%
cp	1457	0.1%

Most occurring characters

Value	Count	Frequency (%)
S	784789	32.2%
F	784789	32.2%
P	339558	13.9%
U	338101	13.9%
C	92614	3.8%
O	91157	3.7%
M	4190	0.2%
H	4190	0.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2439388	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	784789	32.2%
F	784789	32.2%
P	339558	13.9%
U	338101	13.9%
C	92614	3.8%
O	91157	3.7%
M	4190	0.2%
H	4190	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2439388	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	784789	32.2%
F	784789	32.2%
P	339558	13.9%
U	338101	13.9%
C	92614	3.8%
O	91157	3.7%
M	4190	0.2%
H	4190	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2439388	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	784789	32.2%
F	784789	32.2%
P	339558	13.9%
U	338101	13.9%
C	92614	3.8%
O	91157	3.7%
M	4190	0.2%
H	4190	0.2%

Maintenance_and_Preservation_Costs
Real number (ℝ)

Distinct	888
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	55443.636

Minimum	600
Maximum	99900
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.3 MiB

Quantile statistics

Minimum	600
5-th percentile	6600
Q1	29900
median	55100
Q3	85200
95-th percentile	97100
Maximum	99900
Range	99300
Interquartile range (IQR)	55300

Descriptive statistics

Standard deviation	30630.112
Coefficient of variation (CV)	0.55245497
Kurtosis	-1.3493143
Mean	55443.636
Median Absolute Deviation (MAD)	27800
Skewness	-0.12120529
Sum	6.7624271 × 10¹⁰
Variance	9.3820378 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
94500	17057	1.4%
85200	13359	1.1%
84000	12312	1.0%
75000	12126	1.0%
30000	12007	1.0%
98000	10968	0.9%
60000	10567	0.9%
85300	10455	0.9%
20100	9860	0.8%
60600	9438	0.8%
Other values (878)	1101545	90.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
600	39	< 0.1%
700	55	< 0.1%
800	87	< 0.1%
900	112	< 0.1%
1000	1221	0.1%
1100	311	< 0.1%
1200	225	< 0.1%
1300	146	< 0.1%
1400	915	0.1%
1500	2368	0.2%

Value	Count	Frequency (%)
99900	53	< 0.1%
99800	217	< 0.1%
99700	179	< 0.1%
99600	634	0.1%
99500	1117	0.1%
99400	72	< 0.1%
99300	1481	0.1%
99200	1714	0.1%
99100	315	< 0.1%
99000	819	0.1%

Taxes_and_Insurance
Categorical

HIGH CARDINALITY UNIFORM UNIQUE

Distinct	1219694
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	80.3 MiB

F20Q41275812	1
F21Q12090498	1
F21Q12090496	1
F21Q12090495	1
F21Q12090494	1
Other values (1219689)	1219689

Length

Max length	12
Median length	12
Mean length	12
Min length	12

Characters and Unicode

Total characters	14636328
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1219694 ?
Unique (%)	100.0%

Sample

1st row	F20Q41275812
2nd row	F21Q11275813
3rd row	F21Q11275814
4th row	F21Q11275815
5th row	F21Q11275816

Common Values

Value	Count	Frequency (%)
F20Q41275812	1	< 0.1%
F21Q12090498	1	< 0.1%
F21Q12090496	1	< 0.1%
F21Q12090495	1	< 0.1%
F21Q12090494	1	< 0.1%
F21Q12090493	1	< 0.1%
F21Q12090492	1	< 0.1%
F21Q12090491	1	< 0.1%
F21Q12090490	1	< 0.1%
F21Q12090489	1	< 0.1%
Other values (1219684)	1219684	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
f20q41275812	1	< 0.1%
f21q11275816	1	< 0.1%
f21q11275818	1	< 0.1%
f21q11275819	1	< 0.1%
f21q11275820	1	< 0.1%
f21q11275821	1	< 0.1%
f21q11275822	1	< 0.1%
f21q11275823	1	< 0.1%
f21q11275824	1	< 0.1%
f21q11275825	1	< 0.1%
Other values (1219684)	1219684	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
1	3869502	26.4%
2	2447989	16.7%
F	1219694	8.3%
Q	1219694	8.3%
3	807148	5.5%
4	804763	5.5%
8	717300	4.9%
9	715024	4.9%
7	712029	4.9%
6	708246	4.8%
Other values (2)	1414939	9.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	12196940	83.3%
Uppercase Letter	2439388	16.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	3869502	31.7%
2	2447989	20.1%
3	807148	6.6%
4	804763	6.6%
8	717300	5.9%
9	715024	5.9%
7	712029	5.8%
6	708246	5.8%
5	707547	5.8%
0	707392	5.8%

Uppercase Letter

Value	Count	Frequency (%)
F	1219694	50.0%
Q	1219694	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	12196940	83.3%
Latin	2439388	16.7%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	3869502	31.7%
2	2447989	20.1%
3	807148	6.6%
4	804763	6.6%
8	717300	5.9%
9	715024	5.9%
7	712029	5.8%
6	708246	5.8%
5	707547	5.8%
0	707392	5.8%

Latin

Value	Count	Frequency (%)
F	1219694	50.0%
Q	1219694	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14636328	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	3869502	26.4%
2	2447989	16.7%
F	1219694	8.3%
Q	1219694	8.3%
3	807148	5.5%
4	804763	5.5%
8	717300	4.9%
9	715024	4.9%
7	712029	4.9%
6	708246	4.8%
Other values (2)	1414939	9.7%

Miscellaneous_Expenses
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	67.5 MiB

N	665575
P	277384
C	276735

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1219694
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	P
2nd row	C
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	665575	54.6%
P	277384	22.7%
C	276735	22.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n	665575	54.6%
p	277384	22.7%
c	276735	22.7%

Most occurring characters

Value	Count	Frequency (%)
N	665575	54.6%
P	277384	22.7%
C	276735	22.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1219694	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	665575	54.6%
P	277384	22.7%
C	276735	22.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1219694	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	665575	54.6%
P	277384	22.7%
C	276735	22.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1219694	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	665575	54.6%
P	277384	22.7%
C	276735	22.7%

Actual_Loss_Calculation
Real number (ℝ)

Distinct	247
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	316.80677

Minimum	85
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	9.3 MiB

Quantile statistics

Minimum	85
5-th percentile	180
Q1	276
median	360
Q3	360
95-th percentile	360
Maximum	366
Range	281
Interquartile range (IQR)	84

Descriptive statistics

Standard deviation	74.017242
Coefficient of variation (CV)	0.23363529
Kurtosis	-0.20440694
Mean	316.80677
Median Absolute Deviation (MAD)	0
Skewness	-1.2570806
Sum	3.8640732 × 10⁸
Variance	5478.5521
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
360	885358	72.6%
180	212052	17.4%
240	74428	6.1%
300	18499	1.5%
120	12464	1.0%
324	2272	0.2%
348	1824	0.1%
144	1135	0.1%
336	1124	0.1%
312	813	0.1%
Other values (237)	9725	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
85	6	< 0.1%
90	1	< 0.1%
96	293	< 0.1%
97	1	< 0.1%
98	1	< 0.1%
99	1	< 0.1%
100	1	< 0.1%
101	2	< 0.1%
102	1	< 0.1%
106	2	< 0.1%

Value	Count	Frequency (%)
366	8	< 0.1%
365	2	< 0.1%
364	1	< 0.1%
360	885358	72.6%
359	23	< 0.1%
358	3	< 0.1%
357	8	< 0.1%
356	16	< 0.1%
355	19	< 0.1%
354	64	< 0.1%

Modification_Cost
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	67.5 MiB

1	631435
2	580935
3	6252
4	1054
5	18

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1219694
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	2
3rd row	1
4th row	2
5th row	2

Common Values

Value	Count	Frequency (%)
1	631435	51.8%
2	580935	47.6%
3	6252	0.5%
4	1054	0.1%
5	18	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	631435	51.8%
2	580935	47.6%
3	6252	0.5%
4	1054	0.1%
5	18	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
1	631435	51.8%
2	580935	47.6%
3	6252	0.5%
4	1054	0.1%
5	18	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1219694	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	631435	51.8%
2	580935	47.6%
3	6252	0.5%
4	1054	0.1%
5	18	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	1219694	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	631435	51.8%
2	580935	47.6%
3	6252	0.5%
4	1054	0.1%
5	18	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1219694	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	631435	51.8%
2	580935	47.6%
3	6252	0.5%
4	1054	0.1%
5	18	< 0.1%

Step_Modification_Flag
Categorical

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	89.6 MiB

Other sellers	438820
QUICKEN LOANS, LLC	109365
WELLS FARGO BANK, N.A.	61002
PENNYMAC CORP.	60711
UNITED WHOLESALE MORTGAGE, LLC	58230
Other values (16)	491566

Length

Max length	41
Median length	40
Mean length	20.06181
Min length	10

Characters and Unicode

Total characters	24469269
Distinct characters	34
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	WELLS FARGO BANK, N.A.
2nd row	Other sellers
3rd row	Other sellers
4th row	Other sellers
5th row	Other sellers

Common Values

Value	Count	Frequency (%)
Other sellers	438820	36.0%
QUICKEN LOANS, LLC	109365	9.0%
WELLS FARGO BANK, N.A.	61002	5.0%
PENNYMAC CORP.	60711	5.0%
UNITED WHOLESALE MORTGAGE, LLC	58230	4.8%
JPMORGAN CHASE BANK, NATIONAL ASSOCIATION	54860	4.5%
LOANDEPOT.COM, LLC	49895	4.1%
NATIONSTAR MORTGAGE LLC DBA MR. COOPER	48642	4.0%
NEWREZ LLC	44794	3.7%
AMERIHOME MORTGAGE COMPANY, LLC	41636	3.4%
Other values (11)	251739	20.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
other	438820	12.3%
sellers	438820	12.3%
llc	381577	10.7%
mortgage	213662	6.0%
bank	204126	5.7%
loans	138778	3.9%
quicken	109365	3.1%
n.a	89471	2.5%
corporation	83511	2.3%
pennymac	76868	2.2%
Other values (36)	1393849	39.1%

Most occurring characters

Value	Count	Frequency (%)
	2349153	9.6%
O	1953775	8.0%
A	1868194	7.6%
N	1621062	6.6%
L	1340635	5.5%
e	1316460	5.4%
E	1305181	5.3%
C	1135070	4.6%
R	996367	4.1%
r	877640	3.6%
Other values (24)	9705732	39.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	16353673	66.8%
Lowercase Letter	4827020	19.7%
Space Separator	2349153	9.6%
Other Punctuation	939423	3.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	1953775	11.9%
A	1868194	11.4%
N	1621062	9.9%
L	1340635	8.2%
E	1305181	8.0%
C	1135070	6.9%
R	996367	6.1%
I	841302	5.1%
T	812730	5.0%
S	656434	4.0%
Other values (15)	3822923	23.4%

Lowercase Letter

Value	Count	Frequency (%)
e	1316460	27.3%
r	877640	18.2%
s	877640	18.2%
l	877640	18.2%
t	438820	9.1%
h	438820	9.1%

Other Punctuation

Value	Count	Frequency (%)
,	493346	52.5%
.	446077	47.5%

Space Separator

Value	Count	Frequency (%)
	2349153	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	21180693	86.6%
Common	3288576	13.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	1953775	9.2%
A	1868194	8.8%
N	1621062	7.7%
L	1340635	6.3%
e	1316460	6.2%
E	1305181	6.2%
C	1135070	5.4%
R	996367	4.7%
r	877640	4.1%
s	877640	4.1%
Other values (21)	7888669	37.2%

Common

Value	Count	Frequency (%)
	2349153	71.4%
,	493346	15.0%
.	446077	13.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24469269	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	2349153	9.6%
O	1953775	8.0%
A	1868194	7.6%
N	1621062	6.6%
L	1340635	5.5%
e	1316460	5.4%
E	1305181	5.3%
C	1135070	4.6%
R	996367	4.1%
r	877640	3.6%
Other values (24)	9705732	39.7%

Deferred_Payment_Plan
Categorical

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	92.5 MiB

Other servicers	358972
JPMORGAN CHASE BANK, NATIONAL ASSOCIATION	111702
ROCKET MORTGAGE, LLC	82436
WELLS FARGO BANK, N.A.	60938
PENNYMAC CORP.	60710
Other values (20)	544936

Length

Max length	41
Median length	32
Mean length	22.522049
Min length	10

Characters and Unicode

Total characters	27470008
Distinct characters	36
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	WELLS FARGO BANK, N.A.
2nd row	U.S. BANK N.A.
3rd row	U.S. BANK N.A.
4th row	U.S. BANK N.A.
5th row	Other servicers

Common Values

Value	Count	Frequency (%)
Other servicers	358972	29.4%
JPMORGAN CHASE BANK, NATIONAL ASSOCIATION	111702	9.2%
ROCKET MORTGAGE, LLC	82436	6.8%
WELLS FARGO BANK, N.A.	60938	5.0%
PENNYMAC CORP.	60710	5.0%
UNITED WHOLESALE MORTGAGE, LLC	49831	4.1%
NATIONSTAR MORTGAGE LLC DBA MR. COOPER	49592	4.1%
MATRIX FINANCIAL SERVICES CORPORATION	38439	3.2%
LOANDEPOT.COM, LLC	37050	3.0%
NEWREZ LLC	36152	3.0%
Other values (15)	333872	27.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
other	358972	9.4%
servicers	358972	9.4%
llc	333408	8.7%
bank	291813	7.7%
mortgage	284035	7.4%
corporation	145443	3.8%
national	127624	3.3%
association	127624	3.3%
jpmorgan	111702	2.9%
chase	111702	2.9%
Other values (40)	1561864	41.0%

Most occurring characters

Value	Count	Frequency (%)
	2593465	9.4%
A	2376307	8.7%
O	2331642	8.5%
N	1833892	6.7%
R	1358338	4.9%
C	1319891	4.8%
E	1314739	4.8%
L	1295231	4.7%
I	1190861	4.3%
T	1161581	4.2%
Other values (26)	10694061	38.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	19286083	70.2%
Lowercase Letter	4666636	17.0%
Space Separator	2593465	9.4%
Other Punctuation	923824	3.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	2376307	12.3%
O	2331642	12.1%
N	1833892	9.5%
R	1358338	7.0%
C	1319891	6.8%
E	1314739	6.8%
L	1295231	6.7%
I	1190861	6.2%
T	1161581	6.0%
S	832811	4.3%
Other values (15)	4270790	22.1%

Lowercase Letter

Value	Count	Frequency (%)
r	1076916	23.1%
e	1076916	23.1%
s	717944	15.4%
h	358972	7.7%
c	358972	7.7%
t	358972	7.7%
i	358972	7.7%
v	358972	7.7%

Other Punctuation

Value	Count	Frequency (%)
,	489796	53.0%
.	434028	47.0%

Space Separator

Value	Count	Frequency (%)
	2593465	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	23952719	87.2%
Common	3517289	12.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	2376307	9.9%
O	2331642	9.7%
N	1833892	7.7%
R	1358338	5.7%
C	1319891	5.5%
E	1314739	5.5%
L	1295231	5.4%
I	1190861	5.0%
T	1161581	4.8%
r	1076916	4.5%
Other values (23)	8693321	36.3%

Common

Value	Count	Frequency (%)
	2593465	73.7%
,	489796	13.9%
.	434028	12.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	27470008	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	2593465	9.4%
A	2376307	8.7%
O	2331642	8.5%
N	1833892	6.7%
R	1358338	4.9%
C	1319891	4.8%
E	1314739	4.8%
L	1295231	4.7%
I	1190861	4.3%
T	1161581	4.2%
Other values (26)	10694061	38.9%

Estimated_Loan_to_Value_(ELTV)
Boolean

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	1165178
Missing (%)	95.5%
Memory size	2.3 MiB

True	54516
(Missing)	1165178

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	54516	4.5%
(Missing)	1165178	95.5%

Zero_Balance_Removal_UPB
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	1219694
Missing (%)	100.0%
Memory size	9.3 MiB

Delinquent_Accrued_Interest
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	67.5 MiB

9	1175053
H	42747
F	1894

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1219694
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	9
2nd row	9
3rd row	9
4th row	9
5th row	9

Common Values

Value	Count	Frequency (%)
9	1175053	96.3%
H	42747	3.5%
F	1894	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
9	1175053	96.3%
h	42747	3.5%
f	1894	0.2%

Most occurring characters

Value	Count	Frequency (%)
9	1175053	96.3%
H	42747	3.5%
F	1894	0.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1175053	96.3%
Uppercase Letter	44641	3.7%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
H	42747	95.8%
F	1894	4.2%

Decimal Number

Value	Count	Frequency (%)
9	1175053	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1175053	96.3%
Latin	44641	3.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
H	42747	95.8%
F	1894	4.2%

Common

Value	Count	Frequency (%)
9	1175053	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1219694	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
9	1175053	96.3%
H	42747	3.5%
F	1894	0.2%

Delinquency_Due_to_Disaster
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	1219694
Missing (%)	100.0%
Memory size	9.3 MiB

Borrower_Assistance_Status_Code
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	67.5 MiB

2	623360
1	564488
3	31670
9	176

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1219694
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2
2nd row	2
3rd row	1
4th row	2
5th row	1

Common Values

Value	Count	Frequency (%)
2	623360	51.1%
1	564488	46.3%
3	31670	2.6%
9	176	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	623360	51.1%
1	564488	46.3%
3	31670	2.6%
9	176	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
2	623360	51.1%
1	564488	46.3%
3	31670	2.6%
9	176	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1219694	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	623360	51.1%
1	564488	46.3%
3	31670	2.6%
9	176	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	1219694	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	623360	51.1%
1	564488	46.3%
3	31670	2.6%
9	176	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1219694	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	623360	51.1%
1	564488	46.3%
3	31670	2.6%
9	176	< 0.1%

Current_Month_Modification_Cost
Boolean

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

False	1219694

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1219694	100.0%

Interest_Bearing_UPB
Categorical

HIGH CORRELATION IMBALANCE

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	67.5 MiB

7	1006523
N	187742
Y	25429

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1219694
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	7
2nd row	7
3rd row	Y
4th row	7
5th row	7

Common Values

Value	Count	Frequency (%)
7	1006523	82.5%
N	187742	15.4%
Y	25429	2.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
7	1006523	82.5%
n	187742	15.4%
y	25429	2.1%

Most occurring characters

Value	Count	Frequency (%)
7	1006523	82.5%
N	187742	15.4%
Y	25429	2.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1006523	82.5%
Uppercase Letter	213171	17.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	187742	88.1%
Y	25429	11.9%

Decimal Number

Value	Count	Frequency (%)
7	1006523	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1006523	82.5%
Latin	213171	17.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	187742	88.1%
Y	25429	11.9%

Common

Value	Count	Frequency (%)
7	1006523	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1219694	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
7	1006523	82.5%
N	187742	15.4%
Y	25429	2.1%

Auto

Heatmap
Table

	Loan_Sequence_Number	Monthly_Reporting_Period	Current_Loan_Delinquency_Status	Loan_Age	Remaining_Months_to_Legal_Maturity	Zero_Balance_Code	Zero_Balance_Effective_Date	Current_Interest_Rate	Current_Deferred_UPB	Due_Date_of_Last_Paid_Installment_(DDLPI)	Maintenance_and_Preservation_Costs	Actual_Loss_Calculation	Current_Actual_UPB	Defect_Settlement_Date	Modification_Flag	MI_Recoveries	Expenses	Legal_Costs	Miscellaneous_Expenses	Modification_Cost	Step_Modification_Flag	Deferred_Payment_Plan	Delinquent_Accrued_Interest	Borrower_Assistance_Status_Code	Interest_Bearing_UPB
Loan_Sequence_Number	1.000	-0.018	-0.077	-0.001	-0.099	-0.162	-0.183	0.055	-0.160	-0.228	0.025	-0.081	0.007	0.000	0.002	0.005	0.004	0.002	0.010	0.002	0.007	0.009	0.000	0.005	0.003
Monthly_Reporting_Period	-0.018	1.000	0.512	-0.010	0.002	0.001	0.008	-0.029	0.001	0.106	-0.021	-0.037	0.005	0.000	0.004	0.008	0.016	0.005	0.008	0.006	0.012	0.013	0.002	0.010	0.007
Current_Loan_Delinquency_Status	-0.077	0.512	1.000	0.023	0.177	0.265	0.086	0.164	0.264	0.485	0.053	0.799	0.166	0.018	0.045	0.066	0.053	0.034	0.193	0.033	0.061	0.064	0.050	0.090	0.154
Loan_Age	-0.001	-0.010	0.023	1.000	-0.030	-0.050	0.030	0.084	-0.049	0.007	0.162	0.036	0.023	0.050	0.041	0.073	0.561	0.110	0.047	0.016	0.062	0.061	0.029	0.039	0.045
Remaining_Months_to_Legal_Maturity	-0.099	0.002	0.177	-0.030	1.000	0.659	0.068	0.069	0.661	0.069	-0.059	0.212	0.477	0.029	0.087	0.049	0.048	0.037	0.365	0.032	0.046	0.042	0.392	0.171	0.763
Zero_Balance_Code	-0.162	0.001	0.265	-0.050	0.659	1.000	0.099	0.159	0.993	0.208	-0.118	0.320	0.026	0.005	0.003	0.006	0.014	0.002	0.012	0.004	0.019	0.017	0.103	0.006	0.014
Zero_Balance_Effective_Date	-0.183	0.008	0.086	0.030	0.068	0.099	1.000	0.062	0.098	0.130	0.045	0.098	0.000	0.006	0.019	0.002	0.000	0.000	0.002	0.004	0.002	0.001	0.000	0.004	0.001
Current_Interest_Rate	0.055	-0.029	0.164	0.084	0.069	0.159	0.062	1.000	0.152	-0.064	0.159	0.218	0.032	0.119	0.074	0.117	0.164	0.074	0.055	0.068	0.059	0.075	0.074	0.072	0.060
Current_Deferred_UPB	-0.160	0.001	0.264	-0.049	0.661	0.993	0.098	0.152	1.000	0.208	-0.118	0.319	0.500	0.035	0.091	0.054	0.081	0.042	0.403	0.036	0.050	0.049	0.178	0.202	0.706
Due_Date_of_Last_Paid_Installment_(DDLPI)	-0.228	0.106	0.485	0.007	0.069	0.208	0.130	-0.064	0.208	1.000	0.023	0.502	0.067	0.083	0.239	0.062	0.040	0.031	0.152	0.025	0.075	0.082	0.049	0.116	0.088
Maintenance_and_Preservation_Costs	0.025	-0.021	0.053	0.162	-0.059	-0.118	0.045	0.159	-0.118	0.023	1.000	0.079	0.057	0.072	0.077	0.142	0.948	0.174	0.101	0.034	0.101	0.109	0.057	0.075	0.084
Actual_Loss_Calculation	-0.081	-0.037	0.799	0.036	0.212	0.320	0.098	0.218	0.319	0.502	0.079	1.000	0.166	0.018	0.045	0.066	0.053	0.034	0.192	0.033	0.061	0.064	0.050	0.090	0.154
Current_Actual_UPB	0.007	0.005	0.166	0.023	0.477	0.026	0.000	0.032	0.500	0.067	0.057	0.166	1.000	0.016	0.098	0.065	0.077	0.092	0.577	0.066	0.114	0.099	0.233	0.249	0.414
Defect_Settlement_Date	0.000	0.000	0.018	0.050	0.029	0.005	0.006	0.119	0.035	0.083	0.072	0.018	0.016	1.000	0.186	0.015	0.092	0.059	0.012	0.021	0.025	0.026	0.007	0.075	0.031
Modification_Flag	0.002	0.004	0.045	0.041	0.087	0.003	0.019	0.074	0.091	0.239	0.077	0.045	0.098	0.186	1.000	0.027	0.105	0.078	0.100	0.038	0.075	0.080	0.043	0.164	0.074
MI_Recoveries	0.005	0.008	0.066	0.073	0.049	0.006	0.002	0.117	0.054	0.062	0.142	0.066	0.065	0.015	0.027	1.000	0.187	0.052	0.067	0.018	0.600	0.581	0.050	0.068	0.040
Expenses	0.004	0.016	0.053	0.561	0.048	0.014	0.000	0.164	0.081	0.040	0.948	0.053	0.077	0.092	0.105	0.187	1.000	0.230	0.125	0.045	0.102	0.096	0.099	0.106	0.093
Legal_Costs	0.002	0.005	0.034	0.110	0.037	0.002	0.000	0.074	0.042	0.031	0.174	0.034	0.092	0.059	0.078	0.052	0.230	1.000	0.106	0.046	0.072	0.069	0.046	0.051	0.046
Miscellaneous_Expenses	0.010	0.008	0.193	0.047	0.365	0.012	0.002	0.055	0.403	0.152	0.101	0.192	0.577	0.012	0.100	0.067	0.125	0.106	1.000	0.040	0.173	0.169	0.111	0.336	0.324
Modification_Cost	0.002	0.006	0.033	0.016	0.032	0.004	0.004	0.068	0.036	0.025	0.034	0.033	0.066	0.021	0.038	0.018	0.045	0.046	0.040	1.000	0.024	0.023	0.071	0.017	0.039
Step_Modification_Flag	0.007	0.012	0.061	0.062	0.046	0.019	0.002	0.059	0.050	0.075	0.101	0.061	0.114	0.025	0.075	0.600	0.102	0.072	0.173	0.024	1.000	0.864	0.149	0.140	0.078
Deferred_Payment_Plan	0.009	0.013	0.064	0.061	0.042	0.017	0.001	0.075	0.049	0.082	0.109	0.064	0.099	0.026	0.080	0.581	0.096	0.069	0.169	0.023	0.864	1.000	0.141	0.133	0.075
Delinquent_Accrued_Interest	0.000	0.002	0.050	0.029	0.392	0.103	0.000	0.074	0.178	0.049	0.057	0.050	0.233	0.007	0.043	0.050	0.099	0.046	0.111	0.071	0.149	0.141	1.000	0.049	0.151
Borrower_Assistance_Status_Code	0.005	0.010	0.090	0.039	0.171	0.006	0.004	0.072	0.202	0.116	0.075	0.090	0.249	0.075	0.164	0.068	0.106	0.051	0.336	0.017	0.140	0.133	0.049	1.000	0.185
Interest_Bearing_UPB	0.003	0.007	0.154	0.045	0.763	0.014	0.001	0.060	0.706	0.088	0.084	0.154	0.414	0.031	0.074	0.040	0.093	0.046	0.324	0.039	0.078	0.075	0.151	0.185	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Loan_Sequence_Number	Monthly_Reporting_Period	Current_Actual_UPB	Current_Loan_Delinquency_Status	Loan_Age	Remaining_Months_to_Legal_Maturity	Defect_Settlement_Date	Modification_Flag	Zero_Balance_Code	Zero_Balance_Effective_Date	Current_Interest_Rate	Current_Deferred_UPB	Due_Date_of_Last_Paid_Installment_(DDLPI)	MI_Recoveries	Net_Sales_Proceeds	Non_MI_Recoveries	Expenses	Legal_Costs	Maintenance_and_Preservation_Costs	Taxes_and_Insurance	Miscellaneous_Expenses	Actual_Loss_Calculation	Modification_Cost	Step_Modification_Flag	Deferred_Payment_Plan	Estimated_Loan_to_Value_(ELTV)	Zero_Balance_Removal_UPB	Delinquent_Accrued_Interest	Delinquency_Due_to_Disaster	Borrower_Assistance_Status_Code	Current_Month_Modification_Cost	Interest_Bearing_UPB
0	725	202103	Y	205102	15804.0	0	1	P	80	30	298000	80	2.625	C	N	FRM	NJ	PU	8000	F20Q41275812	P	360	1	WELLS FARGO BANK, N.A.	WELLS FARGO BANK, N.A.	NaN	NaN	9	NaN	2	N	7
1	737	202103	N	205102	NaN	0	1	P	74	27	280000	74	2.500	R	N	FRM	CO	SF	81200	F21Q11275813	C	360	2	Other sellers	U.S. BANK N.A.	NaN	NaN	9	NaN	2	N	7
2	744	202105	N	204104	48864.0	6	1	P	85	34	285000	85	2.625	R	N	FRM	DE	SF	19800	F21Q11275814	N	240	1	Other sellers	U.S. BANK N.A.	NaN	NaN	9	NaN	1	N	Y
3	676	202104	N	204103	NaN	0	1	P	79	23	146000	79	3.000	R	N	FRM	KY	SF	40400	F21Q11275815	N	240	2	Other sellers	U.S. BANK N.A.	NaN	NaN	9	NaN	2	N	7
4	765	202103	N	203602	12700.0	0	1	S	60	43	312000	60	2.125	R	N	FRM	MA	SF	2600	F21Q11275816	N	180	2	Other sellers	Other servicers	NaN	NaN	9	NaN	1	N	7
5	686	202103	N	205102	19780.0	0	1	P	80	39	292000	80	3.375	R	N	FRM	IA	SF	50300	F21Q11275817	N	360	2	Other sellers	Other servicers	NaN	NaN	9	NaN	2	N	7
6	762	202103	N	205102	NaN	0	1	P	80	20	352000	80	2.625	R	N	FRM	CO	SF	81200	F21Q11275818	C	360	2	Other sellers	U.S. BANK N.A.	NaN	NaN	9	NaN	2	N	7
7	647	202104	N	205103	NaN	0	1	P	80	34	339000	80	3.500	B	N	FRM	KY	SF	40400	F21Q11275819	N	360	2	Other sellers	U.S. BANK N.A.	NaN	NaN	9	NaN	1	N	7
8	786	202103	N	205102	NaN	0	1	P	77	16	215000	77	2.750	R	N	FRM	VT	SF	5800	F21Q11275820	C	360	2	Other sellers	Other servicers	NaN	NaN	9	NaN	2	N	7
9	749	202103	Y	205102	28740.0	30	1	P	93	45	149000	93	3.000	R	N	FRM	NY	CO	12500	F21Q11275821	P	360	1	Other sellers	Other servicers	NaN	NaN	9	NaN	2	N	N

	Loan_Sequence_Number	Monthly_Reporting_Period	Current_Actual_UPB	Current_Loan_Delinquency_Status	Loan_Age	Remaining_Months_to_Legal_Maturity	Defect_Settlement_Date	Modification_Flag	Zero_Balance_Code	Zero_Balance_Effective_Date	Current_Interest_Rate	Current_Deferred_UPB	Due_Date_of_Last_Paid_Installment_(DDLPI)	MI_Recoveries	Net_Sales_Proceeds	Non_MI_Recoveries	Expenses	Legal_Costs	Maintenance_and_Preservation_Costs	Taxes_and_Insurance	Miscellaneous_Expenses	Actual_Loss_Calculation	Modification_Cost	Step_Modification_Flag	Deferred_Payment_Plan	Estimated_Loan_to_Value_(ELTV)	Zero_Balance_Removal_UPB	Delinquent_Accrued_Interest	Delinquency_Due_to_Disaster	Borrower_Assistance_Status_Code	Current_Month_Modification_Cost	Interest_Bearing_UPB
1219684	704	202210	N	205209	25060.0	0	1	P	69	43	276000	69	4.625	R	N	FRM	MS	SF	39400	F21Q12497610	N	360	2	Other sellers	PHH MORTGAGE CORPORATION	NaN	NaN	9	NaN	2	N	7
1219685	807	202208	N	205203	38060.0	0	1	P	58	20	426000	58	5.150	R	N	FRM	AZ	SF	85200	F21Q12497611	N	356	1	Other sellers	Other servicers	NaN	NaN	9	NaN	2	N	7
1219686	816	202207	N	205201	31540.0	0	1	P	60	38	447000	60	4.050	R	N	FRM	WI	SF	53500	F21Q12497612	N	355	1	Other sellers	Other servicers	NaN	NaN	9	NaN	2	N	7
1219687	778	202204	N	205203	34060.0	0	1	P	39	17	80000	39	3.250	R	N	FRM	WV	SF	26500	F21Q12497613	N	360	2	Other sellers	Other servicers	NaN	NaN	9	NaN	2	N	7
1219688	666	202209	N	205208	35380.0	25	1	P	90	38	408000	90	3.750	C	N	FRM	LA	PU	70000	F21Q12497614	N	360	2	JPMORGAN CHASE BANK, NATIONAL ASSOCIATION	JPMORGAN CHASE BANK, NATIONAL ASSOCIATION	NaN	NaN	9	NaN	2	N	N
1219689	732	202211	N	205210	12940.0	0	1	P	79	41	252000	79	3.125	C	N	FRM	LA	SF	70800	F21Q12497615	N	360	1	JPMORGAN CHASE BANK, NATIONAL ASSOCIATION	JPMORGAN CHASE BANK, NATIONAL ASSOCIATION	NaN	NaN	9	NaN	2	N	7
1219690	803	202203	N	205202	14540.0	30	1	P	93	29	204000	93	3.250	R	N	FRM	KY	SF	42100	F21Q12497616	N	360	1	Other sellers	Other servicers	NaN	NaN	9	NaN	2	N	N
1219691	780	202301	N	205212	27260.0	0	1	S	66	25	510000	66	6.500	R	N	FRM	FL	PU	32200	F21Q12497618	N	360	1	Other sellers	Other servicers	NaN	NaN	9	NaN	2	N	7
1219692	789	202210	N	205209	34940.0	0	1	P	55	48	189000	55	3.125	R	N	FRM	FL	SF	34100	F21Q12497619	P	360	2	CROSSCOUNTRY MORTGAGE, LLC	CROSSCOUNTRY MORTGAGE, LLC	NaN	NaN	9	NaN	2	N	7
1219693	681	202209	N	205208	38940.0	12	1	P	85	33	423000	85	5.875	R	N	FRM	FL	PU	34900	F21Q12497620	N	360	2	Other sellers	Other servicers	NaN	NaN	9	NaN	2	N	N

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values